{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "ec7b4f5f",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sql.SQLServiceMgr import SQLServiceMgr\n",
    "from sql.SqlBaseOperation import *\n",
    "import pandas as pd\n",
    "mgr = SQLServiceMgr()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "f59ca70c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>symbol</th>\n",
       "      <th>time_range</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>(2024-11-27 09:30:00, 2025-05-23 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>(2025-05-26 09:30:00, 2025-05-26 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SHSE.600009</td>\n",
       "      <td>(2024-11-27 09:30:00, 2025-05-23 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SHSE.600009</td>\n",
       "      <td>(2025-05-26 09:30:00, 2025-05-26 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SHSE.600010</td>\n",
       "      <td>(2024-11-27 09:30:00, 2025-05-23 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td>SZSE.300979</td>\n",
       "      <td>(2025-05-26 09:30:00, 2025-05-26 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>594</th>\n",
       "      <td>SZSE.300999</td>\n",
       "      <td>(2024-11-27 09:30:00, 2025-05-23 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>595</th>\n",
       "      <td>SZSE.300999</td>\n",
       "      <td>(2025-05-26 09:30:00, 2025-05-26 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>596</th>\n",
       "      <td>SZSE.301269</td>\n",
       "      <td>(2024-11-27 09:30:00, 2025-05-23 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>597</th>\n",
       "      <td>SZSE.301269</td>\n",
       "      <td>(2025-05-26 09:30:00, 2025-05-26 14:59:00)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>598 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          symbol                                  time_range\n",
       "0    SHSE.600000  (2024-11-27 09:30:00, 2025-05-23 14:59:00)\n",
       "1    SHSE.600000  (2025-05-26 09:30:00, 2025-05-26 14:59:00)\n",
       "2    SHSE.600009  (2024-11-27 09:30:00, 2025-05-23 14:59:00)\n",
       "3    SHSE.600009  (2025-05-26 09:30:00, 2025-05-26 14:59:00)\n",
       "4    SHSE.600010  (2024-11-27 09:30:00, 2025-05-23 14:59:00)\n",
       "..           ...                                         ...\n",
       "593  SZSE.300979  (2025-05-26 09:30:00, 2025-05-26 14:59:00)\n",
       "594  SZSE.300999  (2024-11-27 09:30:00, 2025-05-23 14:59:00)\n",
       "595  SZSE.300999  (2025-05-26 09:30:00, 2025-05-26 14:59:00)\n",
       "596  SZSE.301269  (2024-11-27 09:30:00, 2025-05-23 14:59:00)\n",
       "597  SZSE.301269  (2025-05-26 09:30:00, 2025-05-26 14:59:00)\n",
       "\n",
       "[598 rows x 2 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mgr.show_exist_symbols('min')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "3d452111",
   "metadata": {},
   "outputs": [],
   "source": [
    "symbol = 'SHSE.600000'\n",
    "start_time = '2024-11-27 08:00:00'\n",
    "end_time = '2025-05-25 15:00:00'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "d7a316ee",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>symbol</th>\n",
       "      <th>time</th>\n",
       "      <th>open</th>\n",
       "      <th>close</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>volume</th>\n",
       "      <th>amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>2024-11-27</td>\n",
       "      <td>9.31</td>\n",
       "      <td>9.43</td>\n",
       "      <td>9.47</td>\n",
       "      <td>9.18</td>\n",
       "      <td>43007443.0</td>\n",
       "      <td>401498755.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>2024-11-28</td>\n",
       "      <td>9.49</td>\n",
       "      <td>9.44</td>\n",
       "      <td>9.54</td>\n",
       "      <td>9.33</td>\n",
       "      <td>39154733.0</td>\n",
       "      <td>370385580.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>2024-11-29</td>\n",
       "      <td>9.52</td>\n",
       "      <td>9.46</td>\n",
       "      <td>9.61</td>\n",
       "      <td>9.43</td>\n",
       "      <td>46540742.0</td>\n",
       "      <td>443290385.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>2024-12-02</td>\n",
       "      <td>9.45</td>\n",
       "      <td>9.49</td>\n",
       "      <td>9.50</td>\n",
       "      <td>9.37</td>\n",
       "      <td>46604260.0</td>\n",
       "      <td>440070881.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>2024-12-03</td>\n",
       "      <td>9.46</td>\n",
       "      <td>9.65</td>\n",
       "      <td>9.65</td>\n",
       "      <td>9.41</td>\n",
       "      <td>41926355.0</td>\n",
       "      <td>400570471.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>2025-05-19</td>\n",
       "      <td>12.20</td>\n",
       "      <td>12.00</td>\n",
       "      <td>12.25</td>\n",
       "      <td>11.97</td>\n",
       "      <td>63137397.0</td>\n",
       "      <td>762689367.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>2025-05-20</td>\n",
       "      <td>12.02</td>\n",
       "      <td>12.27</td>\n",
       "      <td>12.34</td>\n",
       "      <td>12.01</td>\n",
       "      <td>80013453.0</td>\n",
       "      <td>976894439.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>2025-05-21</td>\n",
       "      <td>12.27</td>\n",
       "      <td>12.27</td>\n",
       "      <td>12.42</td>\n",
       "      <td>12.20</td>\n",
       "      <td>41672064.0</td>\n",
       "      <td>513339136.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>2025-05-22</td>\n",
       "      <td>12.22</td>\n",
       "      <td>12.43</td>\n",
       "      <td>12.53</td>\n",
       "      <td>12.19</td>\n",
       "      <td>63895089.0</td>\n",
       "      <td>792331667.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>2025-05-23</td>\n",
       "      <td>12.39</td>\n",
       "      <td>12.23</td>\n",
       "      <td>12.48</td>\n",
       "      <td>12.22</td>\n",
       "      <td>57961597.0</td>\n",
       "      <td>712934903.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>117 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          symbol        time   open  close   high    low      volume  \\\n",
       "0    SHSE.600000  2024-11-27   9.31   9.43   9.47   9.18  43007443.0   \n",
       "1    SHSE.600000  2024-11-28   9.49   9.44   9.54   9.33  39154733.0   \n",
       "2    SHSE.600000  2024-11-29   9.52   9.46   9.61   9.43  46540742.0   \n",
       "3    SHSE.600000  2024-12-02   9.45   9.49   9.50   9.37  46604260.0   \n",
       "4    SHSE.600000  2024-12-03   9.46   9.65   9.65   9.41  41926355.0   \n",
       "..           ...         ...    ...    ...    ...    ...         ...   \n",
       "112  SHSE.600000  2025-05-19  12.20  12.00  12.25  11.97  63137397.0   \n",
       "113  SHSE.600000  2025-05-20  12.02  12.27  12.34  12.01  80013453.0   \n",
       "114  SHSE.600000  2025-05-21  12.27  12.27  12.42  12.20  41672064.0   \n",
       "115  SHSE.600000  2025-05-22  12.22  12.43  12.53  12.19  63895089.0   \n",
       "116  SHSE.600000  2025-05-23  12.39  12.23  12.48  12.22  57961597.0   \n",
       "\n",
       "          amount  \n",
       "0    401498755.0  \n",
       "1    370385580.0  \n",
       "2    443290385.0  \n",
       "3    440070881.0  \n",
       "4    400570471.0  \n",
       "..           ...  \n",
       "112  762689367.0  \n",
       "113  976894439.0  \n",
       "114  513339136.0  \n",
       "115  792331667.0  \n",
       "116  712934903.0  \n",
       "\n",
       "[117 rows x 8 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mgr.history([symbol],start_time,end_time,'day')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "1a439ea5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['SHSE.601865',\n",
       "  'SHSE.601377',\n",
       "  'SHSE.601901',\n",
       "  'SHSE.601688',\n",
       "  'SHSE.601788',\n",
       "  'SHSE.600809',\n",
       "  'SZSE.000768',\n",
       "  'SZSE.000776',\n",
       "  'SZSE.000786',\n",
       "  'SHSE.600893',\n",
       "  'SZSE.000792',\n",
       "  'SZSE.000800',\n",
       "  'SZSE.000807',\n",
       "  'SHSE.601818',\n",
       "  'SHSE.601398',\n",
       "  'SHSE.601939',\n",
       "  'SHSE.601166',\n",
       "  'SHSE.600160',\n",
       "  'SHSE.600161',\n",
       "  'SZSE.000001',\n",
       "  'SZSE.000002',\n",
       "  'SHSE.600183',\n",
       "  'SHSE.600188',\n",
       "  'SHSE.600196',\n",
       "  'SHSE.600219',\n",
       "  'SZSE.000895',\n",
       "  'SHSE.600362',\n",
       "  'SHSE.600372',\n",
       "  'SHSE.600377',\n",
       "  'SZSE.000938',\n",
       "  'SZSE.000963',\n",
       "  'SHSE.600999',\n",
       "  'SHSE.600415',\n",
       "  'SHSE.600426',\n",
       "  'SHSE.600031',\n",
       "  'SHSE.600585',\n",
       "  'SHSE.600588',\n",
       "  'SHSE.600600',\n",
       "  'SHSE.600029',\n",
       "  'SHSE.600489',\n",
       "  'SHSE.600547',\n",
       "  'SHSE.600406',\n",
       "  'SHSE.600900',\n",
       "  'SZSE.002594',\n",
       "  'SHSE.601288',\n",
       "  'SHSE.601328',\n",
       "  'SHSE.601988',\n",
       "  'SHSE.600027',\n",
       "  'SZSE.002049',\n",
       "  'SZSE.002050',\n",
       "  'SZSE.000063',\n",
       "  'SZSE.000157',\n",
       "  'SHSE.601633',\n",
       "  'SHSE.601899',\n",
       "  'SZSE.000301',\n",
       "  'SZSE.000408',\n",
       "  'SHSE.600515',\n",
       "  'SHSE.600519',\n",
       "  'SHSE.600000',\n",
       "  'SHSE.600009',\n",
       "  'SHSE.600010',\n",
       "  'SHSE.600011',\n",
       "  'SHSE.600016',\n",
       "  'SHSE.600019',\n",
       "  'SHSE.600026',\n",
       "  'SHSE.600028',\n",
       "  'SHSE.600030',\n",
       "  'SHSE.600036',\n",
       "  'SHSE.600050',\n",
       "  'SHSE.600061',\n",
       "  'SHSE.600066',\n",
       "  'SHSE.600233',\n",
       "  'SHSE.600276',\n",
       "  'SHSE.600660',\n",
       "  'SHSE.600674',\n",
       "  'SZSE.000100',\n",
       "  'SZSE.000975',\n",
       "  'SZSE.000983',\n",
       "  'SZSE.000999',\n",
       "  'SHSE.600039',\n",
       "  'SHSE.600584',\n",
       "  'SHSE.600436',\n",
       "  'SHSE.601998',\n",
       "  'SZSE.000425',\n",
       "  'SHSE.600760',\n",
       "  'SHSE.600309',\n",
       "  'SHSE.600332',\n",
       "  'SHSE.600346',\n",
       "  'SHSE.600795',\n",
       "  'SHSE.600803',\n",
       "  'SHSE.600085',\n",
       "  'SHSE.600089',\n",
       "  'SHSE.600104',\n",
       "  'SHSE.600111',\n",
       "  'SHSE.600115',\n",
       "  'SHSE.600690',\n",
       "  'SHSE.600150',\n",
       "  'SZSE.002007',\n",
       "  'SHSE.600482',\n",
       "  'SZSE.002027',\n",
       "  'SHSE.600741',\n",
       "  'SHSE.600745',\n",
       "  'SZSE.000858',\n",
       "  'SZSE.000876',\n",
       "  'SZSE.000568',\n",
       "  'SZSE.000708',\n",
       "  'SZSE.000725',\n",
       "  'SHSE.601628',\n",
       "  'SHSE.601318',\n",
       "  'SHSE.601601',\n",
       "  'SHSE.601336',\n",
       "  'SHSE.600018',\n",
       "  'SHSE.601009',\n",
       "  'SHSE.600845',\n",
       "  'SHSE.601607',\n",
       "  'SZSE.000596',\n",
       "  'SZSE.000617',\n",
       "  'SZSE.000630',\n",
       "  'SZSE.000651',\n",
       "  'SZSE.000661',\n",
       "  'SHSE.600875',\n",
       "  'SHSE.600886',\n",
       "  'SHSE.600887',\n",
       "  'SHSE.601857',\n",
       "  'SHSE.601600',\n",
       "  'SZSE.002230',\n",
       "  'SHSE.601111',\n",
       "  'SHSE.601669',\n",
       "  'SHSE.601808',\n",
       "  'SHSE.601699',\n",
       "  'SZSE.002463',\n",
       "  'SHSE.601898',\n",
       "  'SHSE.600048',\n",
       "  'SHSE.601006',\n",
       "  'SZSE.002074',\n",
       "  'SHSE.601058',\n",
       "  'SHSE.601800',\n",
       "  'SHSE.601872',\n",
       "  'SZSE.002371',\n",
       "  'SHSE.601390',\n",
       "  'SZSE.002180',\n",
       "  'SZSE.002179',\n",
       "  'SZSE.002304',\n",
       "  'SHSE.601766',\n",
       "  'SHSE.601238',\n",
       "  'SZSE.002241',\n",
       "  'SHSE.601186',\n",
       "  'SZSE.002252',\n",
       "  'SZSE.002236',\n",
       "  'SHSE.601668',\n",
       "  'SZSE.002601',\n",
       "  'SZSE.002271',\n",
       "  'SZSE.002422',\n",
       "  'SZSE.002311',\n",
       "  'SHSE.601877',\n",
       "  'SZSE.002493',\n",
       "  'SZSE.300274',\n",
       "  'SHSE.601989',\n",
       "  'SHSE.601117',\n",
       "  'SHSE.601618',\n",
       "  'SZSE.002475',\n",
       "  'SHSE.601100',\n",
       "  'SZSE.002415',\n",
       "  'SHSE.601888',\n",
       "  'SZSE.300033',\n",
       "  'SHSE.601799',\n",
       "  'SZSE.300014',\n",
       "  'SZSE.300015',\n",
       "  'SHSE.601012',\n",
       "  'SZSE.002352',\n",
       "  'SZSE.300124',\n",
       "  'SZSE.002459',\n",
       "  'SZSE.002466',\n",
       "  'SZSE.300122',\n",
       "  'SZSE.002555',\n",
       "  'SHSE.600570',\n",
       "  'SHSE.600015',\n",
       "  'SHSE.600438',\n",
       "  'SZSE.002001',\n",
       "  'SZSE.002028',\n",
       "  'SHSE.601088',\n",
       "  'SZSE.002129',\n",
       "  'SHSE.600176',\n",
       "  'SZSE.000538',\n",
       "  'SZSE.000625',\n",
       "  'SZSE.000977',\n",
       "  'SHSE.600460',\n",
       "  'SHSE.601169',\n",
       "  'SZSE.000338',\n",
       "  'SHSE.601919',\n",
       "  'SZSE.002142',\n",
       "  'SZSE.300059',\n",
       "  'SZSE.002460',\n",
       "  'SZSE.002648',\n",
       "  'SZSE.300308',\n",
       "  'SZSE.300316',\n",
       "  'SZSE.300347',\n",
       "  'SHSE.601225',\n",
       "  'SZSE.002714',\n",
       "  'SZSE.002709',\n",
       "  'SHSE.603288',\n",
       "  'SHSE.603993',\n",
       "  'SZSE.000333',\n",
       "  'SHSE.600023',\n",
       "  'SHSE.601211',\n",
       "  'SHSE.600958',\n",
       "  'SHSE.601689',\n",
       "  'SHSE.603369',\n",
       "  'SHSE.601021',\n",
       "  'SZSE.300418',\n",
       "  'SHSE.603806',\n",
       "  'SHSE.601985',\n",
       "  'SHSE.603986',\n",
       "  'SZSE.300433',\n",
       "  'SZSE.300442',\n",
       "  'SHSE.601127',\n",
       "  'SZSE.002812',\n",
       "  'SHSE.603019',\n",
       "  'SZSE.002736',\n",
       "  'SHSE.601878',\n",
       "  'SZSE.300450',\n",
       "  'SZSE.300502',\n",
       "  'SHSE.688506',\n",
       "  'SZSE.300394',\n",
       "  'SHSE.600926',\n",
       "  'SHSE.600919',\n",
       "  'SHSE.601229',\n",
       "  'SHSE.601838',\n",
       "  'SZSE.300408',\n",
       "  'SZSE.300413',\n",
       "  'SHSE.601881',\n",
       "  'SHSE.603833',\n",
       "  'SHSE.603799',\n",
       "  'SZSE.000166',\n",
       "  'SHSE.603501',\n",
       "  'SZSE.300498',\n",
       "  'SZSE.300628',\n",
       "  'SZSE.300661',\n",
       "  'SZSE.001979',\n",
       "  'SHSE.603260',\n",
       "  'SHSE.600918',\n",
       "  'SZSE.300832',\n",
       "  'SZSE.002920',\n",
       "  'SHSE.600025',\n",
       "  'SHSE.603659',\n",
       "  'SHSE.603392',\n",
       "  'SZSE.002916',\n",
       "  'SZSE.300760',\n",
       "  'SHSE.688111',\n",
       "  'SHSE.601066',\n",
       "  'SZSE.300759',\n",
       "  'SZSE.300896',\n",
       "  'SHSE.603259',\n",
       "  'SHSE.601236',\n",
       "  'SHSE.601319',\n",
       "  'SHSE.601916',\n",
       "  'SZSE.300750',\n",
       "  'SZSE.002938',\n",
       "  'SZSE.001965',\n",
       "  'SHSE.600989',\n",
       "  'SHSE.601698',\n",
       "  'SHSE.601138',\n",
       "  'SHSE.601360',\n",
       "  'SZSE.300782',\n",
       "  'SZSE.003816',\n",
       "  'SHSE.603195',\n",
       "  'SHSE.688036',\n",
       "  'SHSE.688009',\n",
       "  'SHSE.688012',\n",
       "  'SHSE.688008',\n",
       "  'SHSE.688169',\n",
       "  'SHSE.688126',\n",
       "  'SHSE.688599',\n",
       "  'SHSE.688396',\n",
       "  'SHSE.605117',\n",
       "  'SHSE.601658',\n",
       "  'SZSE.300999',\n",
       "  'SHSE.601816',\n",
       "  'SHSE.688256',\n",
       "  'SHSE.600905',\n",
       "  'SHSE.605499',\n",
       "  'SHSE.601995',\n",
       "  'SHSE.688082',\n",
       "  'SHSE.688981',\n",
       "  'SZSE.300979',\n",
       "  'SHSE.688303',\n",
       "  'SHSE.688187',\n",
       "  'SHSE.601059',\n",
       "  'SHSE.601728',\n",
       "  'SHSE.600941',\n",
       "  'SZSE.301269',\n",
       "  'SHSE.688472',\n",
       "  'SHSE.688223',\n",
       "  'SHSE.603296',\n",
       "  'SHSE.601868',\n",
       "  'SHSE.601136',\n",
       "  'SHSE.688041',\n",
       "  'SHSE.600938',\n",
       "  'SHSE.688271',\n",
       "  'SZSE.001289']]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mgr.get_group_positions(['SHSE.000300'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "4239fac3",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=mgr.history([symbol],start_time,end_time,'min')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "966d0eb5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>time</th>\n",
       "      <th>amount</th>\n",
       "      <th>low</th>\n",
       "      <th>high</th>\n",
       "      <th>open</th>\n",
       "      <th>symbol</th>\n",
       "      <th>close</th>\n",
       "      <th>volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2024-11-27 09:30:00</td>\n",
       "      <td>7210240.0</td>\n",
       "      <td>9.28</td>\n",
       "      <td>9.33</td>\n",
       "      <td>9.31</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>9.32</td>\n",
       "      <td>774750.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2024-11-27 09:31:00</td>\n",
       "      <td>3458349.0</td>\n",
       "      <td>9.31</td>\n",
       "      <td>9.34</td>\n",
       "      <td>9.31</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>9.32</td>\n",
       "      <td>370800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2024-11-27 09:32:00</td>\n",
       "      <td>4997465.0</td>\n",
       "      <td>9.32</td>\n",
       "      <td>9.35</td>\n",
       "      <td>9.32</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>9.32</td>\n",
       "      <td>535700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2024-11-27 09:33:00</td>\n",
       "      <td>2885258.0</td>\n",
       "      <td>9.30</td>\n",
       "      <td>9.32</td>\n",
       "      <td>9.32</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>9.32</td>\n",
       "      <td>309800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2024-11-27 09:34:00</td>\n",
       "      <td>3076321.0</td>\n",
       "      <td>9.31</td>\n",
       "      <td>9.33</td>\n",
       "      <td>9.32</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>9.32</td>\n",
       "      <td>330100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27910</th>\n",
       "      <td>2025-05-23 14:53:00</td>\n",
       "      <td>2669756.0</td>\n",
       "      <td>12.24</td>\n",
       "      <td>12.25</td>\n",
       "      <td>12.25</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>12.25</td>\n",
       "      <td>218000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27911</th>\n",
       "      <td>2025-05-23 14:54:00</td>\n",
       "      <td>4001547.0</td>\n",
       "      <td>12.24</td>\n",
       "      <td>12.25</td>\n",
       "      <td>12.24</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>12.24</td>\n",
       "      <td>326823.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27912</th>\n",
       "      <td>2025-05-23 14:55:00</td>\n",
       "      <td>5070318.0</td>\n",
       "      <td>12.23</td>\n",
       "      <td>12.24</td>\n",
       "      <td>12.23</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>12.23</td>\n",
       "      <td>414396.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27913</th>\n",
       "      <td>2025-05-23 14:56:00</td>\n",
       "      <td>5563395.0</td>\n",
       "      <td>12.22</td>\n",
       "      <td>12.25</td>\n",
       "      <td>12.23</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>12.24</td>\n",
       "      <td>454700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27914</th>\n",
       "      <td>2025-05-23 14:59:00</td>\n",
       "      <td>10973979.0</td>\n",
       "      <td>12.23</td>\n",
       "      <td>12.23</td>\n",
       "      <td>12.23</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>12.23</td>\n",
       "      <td>897300.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>27915 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     time      amount    low   high   open       symbol  \\\n",
       "0     2024-11-27 09:30:00   7210240.0   9.28   9.33   9.31  SHSE.600000   \n",
       "1     2024-11-27 09:31:00   3458349.0   9.31   9.34   9.31  SHSE.600000   \n",
       "2     2024-11-27 09:32:00   4997465.0   9.32   9.35   9.32  SHSE.600000   \n",
       "3     2024-11-27 09:33:00   2885258.0   9.30   9.32   9.32  SHSE.600000   \n",
       "4     2024-11-27 09:34:00   3076321.0   9.31   9.33   9.32  SHSE.600000   \n",
       "...                   ...         ...    ...    ...    ...          ...   \n",
       "27910 2025-05-23 14:53:00   2669756.0  12.24  12.25  12.25  SHSE.600000   \n",
       "27911 2025-05-23 14:54:00   4001547.0  12.24  12.25  12.24  SHSE.600000   \n",
       "27912 2025-05-23 14:55:00   5070318.0  12.23  12.24  12.23  SHSE.600000   \n",
       "27913 2025-05-23 14:56:00   5563395.0  12.22  12.25  12.23  SHSE.600000   \n",
       "27914 2025-05-23 14:59:00  10973979.0  12.23  12.23  12.23  SHSE.600000   \n",
       "\n",
       "       close    volume  \n",
       "0       9.32  774750.0  \n",
       "1       9.32  370800.0  \n",
       "2       9.32  535700.0  \n",
       "3       9.32  309800.0  \n",
       "4       9.32  330100.0  \n",
       "...      ...       ...  \n",
       "27910  12.25  218000.0  \n",
       "27911  12.24  326823.0  \n",
       "27912  12.23  414396.0  \n",
       "27913  12.24  454700.0  \n",
       "27914  12.23  897300.0  \n",
       "\n",
       "[27915 rows x 8 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "f2967ba5",
   "metadata": {},
   "outputs": [],
   "source": [
    "mgr.delete_symbol(symbol,'min',start_time=start_time,end_time=end_time,force=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "1499c711",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>symbol</th>\n",
       "      <th>time_range</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>(2025-05-26 09:30:00, 2025-05-26 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SHSE.600009</td>\n",
       "      <td>(2024-11-27 09:30:00, 2025-05-23 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SHSE.600009</td>\n",
       "      <td>(2025-05-26 09:30:00, 2025-05-26 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SHSE.600010</td>\n",
       "      <td>(2024-11-27 09:30:00, 2025-05-23 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SHSE.600010</td>\n",
       "      <td>(2025-05-26 09:30:00, 2025-05-26 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>592</th>\n",
       "      <td>SZSE.300979</td>\n",
       "      <td>(2025-05-26 09:30:00, 2025-05-26 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td>SZSE.300999</td>\n",
       "      <td>(2024-11-27 09:30:00, 2025-05-23 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>594</th>\n",
       "      <td>SZSE.300999</td>\n",
       "      <td>(2025-05-26 09:30:00, 2025-05-26 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>595</th>\n",
       "      <td>SZSE.301269</td>\n",
       "      <td>(2024-11-27 09:30:00, 2025-05-23 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>596</th>\n",
       "      <td>SZSE.301269</td>\n",
       "      <td>(2025-05-26 09:30:00, 2025-05-26 14:59:00)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>597 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          symbol                                  time_range\n",
       "0    SHSE.600000  (2025-05-26 09:30:00, 2025-05-26 14:59:00)\n",
       "1    SHSE.600009  (2024-11-27 09:30:00, 2025-05-23 14:59:00)\n",
       "2    SHSE.600009  (2025-05-26 09:30:00, 2025-05-26 14:59:00)\n",
       "3    SHSE.600010  (2024-11-27 09:30:00, 2025-05-23 14:59:00)\n",
       "4    SHSE.600010  (2025-05-26 09:30:00, 2025-05-26 14:59:00)\n",
       "..           ...                                         ...\n",
       "592  SZSE.300979  (2025-05-26 09:30:00, 2025-05-26 14:59:00)\n",
       "593  SZSE.300999  (2024-11-27 09:30:00, 2025-05-23 14:59:00)\n",
       "594  SZSE.300999  (2025-05-26 09:30:00, 2025-05-26 14:59:00)\n",
       "595  SZSE.301269  (2024-11-27 09:30:00, 2025-05-23 14:59:00)\n",
       "596  SZSE.301269  (2025-05-26 09:30:00, 2025-05-26 14:59:00)\n",
       "\n",
       "[597 rows x 2 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mgr.show_exist_symbols('min')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "ec2bed47",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>time</th>\n",
       "      <th>amount</th>\n",
       "      <th>low</th>\n",
       "      <th>high</th>\n",
       "      <th>open</th>\n",
       "      <th>symbol</th>\n",
       "      <th>close</th>\n",
       "      <th>volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [time, amount, low, high, open, symbol, close, volume]\n",
       "Index: []"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mgr.history([symbol],start_time,end_time,'min')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "8c523eb7",
   "metadata": {},
   "outputs": [],
   "source": [
    "mgr.insert_new_symbol(df,'min')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "38260809",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>time</th>\n",
       "      <th>amount</th>\n",
       "      <th>low</th>\n",
       "      <th>high</th>\n",
       "      <th>open</th>\n",
       "      <th>symbol</th>\n",
       "      <th>close</th>\n",
       "      <th>volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2024-11-27 09:30:00</td>\n",
       "      <td>7210240.0</td>\n",
       "      <td>9.28</td>\n",
       "      <td>9.33</td>\n",
       "      <td>9.31</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>9.32</td>\n",
       "      <td>774750.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2024-11-27 09:31:00</td>\n",
       "      <td>3458349.0</td>\n",
       "      <td>9.31</td>\n",
       "      <td>9.34</td>\n",
       "      <td>9.31</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>9.32</td>\n",
       "      <td>370800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2024-11-27 09:32:00</td>\n",
       "      <td>4997465.0</td>\n",
       "      <td>9.32</td>\n",
       "      <td>9.35</td>\n",
       "      <td>9.32</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>9.32</td>\n",
       "      <td>535700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2024-11-27 09:33:00</td>\n",
       "      <td>2885258.0</td>\n",
       "      <td>9.30</td>\n",
       "      <td>9.32</td>\n",
       "      <td>9.32</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>9.32</td>\n",
       "      <td>309800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2024-11-27 09:34:00</td>\n",
       "      <td>3076321.0</td>\n",
       "      <td>9.31</td>\n",
       "      <td>9.33</td>\n",
       "      <td>9.32</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>9.32</td>\n",
       "      <td>330100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27910</th>\n",
       "      <td>2025-05-23 14:53:00</td>\n",
       "      <td>2669756.0</td>\n",
       "      <td>12.24</td>\n",
       "      <td>12.25</td>\n",
       "      <td>12.25</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>12.25</td>\n",
       "      <td>218000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27911</th>\n",
       "      <td>2025-05-23 14:54:00</td>\n",
       "      <td>4001547.0</td>\n",
       "      <td>12.24</td>\n",
       "      <td>12.25</td>\n",
       "      <td>12.24</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>12.24</td>\n",
       "      <td>326823.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27912</th>\n",
       "      <td>2025-05-23 14:55:00</td>\n",
       "      <td>5070318.0</td>\n",
       "      <td>12.23</td>\n",
       "      <td>12.24</td>\n",
       "      <td>12.23</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>12.23</td>\n",
       "      <td>414396.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27913</th>\n",
       "      <td>2025-05-23 14:56:00</td>\n",
       "      <td>5563395.0</td>\n",
       "      <td>12.22</td>\n",
       "      <td>12.25</td>\n",
       "      <td>12.23</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>12.24</td>\n",
       "      <td>454700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27914</th>\n",
       "      <td>2025-05-23 14:59:00</td>\n",
       "      <td>10973979.0</td>\n",
       "      <td>12.23</td>\n",
       "      <td>12.23</td>\n",
       "      <td>12.23</td>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>12.23</td>\n",
       "      <td>897300.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>27915 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     time      amount    low   high   open       symbol  \\\n",
       "0     2024-11-27 09:30:00   7210240.0   9.28   9.33   9.31  SHSE.600000   \n",
       "1     2024-11-27 09:31:00   3458349.0   9.31   9.34   9.31  SHSE.600000   \n",
       "2     2024-11-27 09:32:00   4997465.0   9.32   9.35   9.32  SHSE.600000   \n",
       "3     2024-11-27 09:33:00   2885258.0   9.30   9.32   9.32  SHSE.600000   \n",
       "4     2024-11-27 09:34:00   3076321.0   9.31   9.33   9.32  SHSE.600000   \n",
       "...                   ...         ...    ...    ...    ...          ...   \n",
       "27910 2025-05-23 14:53:00   2669756.0  12.24  12.25  12.25  SHSE.600000   \n",
       "27911 2025-05-23 14:54:00   4001547.0  12.24  12.25  12.24  SHSE.600000   \n",
       "27912 2025-05-23 14:55:00   5070318.0  12.23  12.24  12.23  SHSE.600000   \n",
       "27913 2025-05-23 14:56:00   5563395.0  12.22  12.25  12.23  SHSE.600000   \n",
       "27914 2025-05-23 14:59:00  10973979.0  12.23  12.23  12.23  SHSE.600000   \n",
       "\n",
       "       close    volume  \n",
       "0       9.32  774750.0  \n",
       "1       9.32  370800.0  \n",
       "2       9.32  535700.0  \n",
       "3       9.32  309800.0  \n",
       "4       9.32  330100.0  \n",
       "...      ...       ...  \n",
       "27910  12.25  218000.0  \n",
       "27911  12.24  326823.0  \n",
       "27912  12.23  414396.0  \n",
       "27913  12.24  454700.0  \n",
       "27914  12.23  897300.0  \n",
       "\n",
       "[27915 rows x 8 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mgr.history([symbol],start_time,end_time,'min')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "3ddbb45a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>symbol</th>\n",
       "      <th>time_range</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>(2024-11-27 09:30:00, 2025-05-23 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SHSE.600000</td>\n",
       "      <td>(2025-05-26 09:30:00, 2025-05-26 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SHSE.600009</td>\n",
       "      <td>(2024-11-27 09:30:00, 2025-05-23 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SHSE.600009</td>\n",
       "      <td>(2025-05-26 09:30:00, 2025-05-26 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SHSE.600010</td>\n",
       "      <td>(2024-11-27 09:30:00, 2025-05-23 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td>SZSE.300979</td>\n",
       "      <td>(2025-05-26 09:30:00, 2025-05-26 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>594</th>\n",
       "      <td>SZSE.300999</td>\n",
       "      <td>(2024-11-27 09:30:00, 2025-05-23 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>595</th>\n",
       "      <td>SZSE.300999</td>\n",
       "      <td>(2025-05-26 09:30:00, 2025-05-26 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>596</th>\n",
       "      <td>SZSE.301269</td>\n",
       "      <td>(2024-11-27 09:30:00, 2025-05-23 14:59:00)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>597</th>\n",
       "      <td>SZSE.301269</td>\n",
       "      <td>(2025-05-26 09:30:00, 2025-05-26 14:59:00)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>598 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          symbol                                  time_range\n",
       "0    SHSE.600000  (2024-11-27 09:30:00, 2025-05-23 14:59:00)\n",
       "1    SHSE.600000  (2025-05-26 09:30:00, 2025-05-26 14:59:00)\n",
       "2    SHSE.600009  (2024-11-27 09:30:00, 2025-05-23 14:59:00)\n",
       "3    SHSE.600009  (2025-05-26 09:30:00, 2025-05-26 14:59:00)\n",
       "4    SHSE.600010  (2024-11-27 09:30:00, 2025-05-23 14:59:00)\n",
       "..           ...                                         ...\n",
       "593  SZSE.300979  (2025-05-26 09:30:00, 2025-05-26 14:59:00)\n",
       "594  SZSE.300999  (2024-11-27 09:30:00, 2025-05-23 14:59:00)\n",
       "595  SZSE.300999  (2025-05-26 09:30:00, 2025-05-26 14:59:00)\n",
       "596  SZSE.301269  (2024-11-27 09:30:00, 2025-05-23 14:59:00)\n",
       "597  SZSE.301269  (2025-05-26 09:30:00, 2025-05-26 14:59:00)\n",
       "\n",
       "[598 rows x 2 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mgr.show_exist_symbols('min')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
